'

Question: (a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) Click here for the Excel Data File

(b) Calculate the sample correlation coefficient. Check your work by using Excel\'s function =CORREL(array1, array2). (Round your answer to 4 decimal places.)

(c) Find t.025 for a two-tailed test for zero correlation at α=0.05 . (Round your answer to 3 decimal places.)

(d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.)

(d-2) Should we reject the null hypothesis of zero correlation?

multiple choice

No

Yes

(e) Use Excel\'s function =T.DIST.2T(t,deg_freedom) to calculate the two-tail p-value. (Round your answer to 4 decimal places.)